UPDATE JOIN
Редактировал(а) Alexandr Fokin 2023/12/16 14:12
update tmpTable1 as t1
set
property1 = dt.property1
from
(
select query...
) as dt
where t1.id = dt.id
set
property1 = dt.property1
from
(
select query...
) as dt
where t1.id = dt.id
How to do an update + join in PostgreSQL?
https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql